<?php
   include "user.inc.php";
   include "mysql.inc.php";
   $m=new CMySQL($dbserver,$dbuser,$dbpsd,$dbname);


$sql="CREATE TABLE `projects` (  `PID` int(11) NOT NULL auto_increment,  `UID` int(11) NOT NULL,  `PNAME` varchar(128) NOT NULL,  `COMPANY` varchar(128) NOT NULL,  `RTIME` datetime NOT NULL,  `ETIME` datetime NOT NULL,  `CEMAIL` varchar(128) NOT NULL,  `MEMO` varchar(1024) NOT NULL,  PRIMARY KEY  (`PID`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";   $m->DoQueryNoReturn($sql);
$sql="CREATE TABLE `user` (  `UID` int(11) NOT NULL auto_increment,  `NAME` varchar(128) NOT NULL,  `PSD` varchar(32) NOT NULL,  `SNO` varchar(32) NOT NULL,  `EMAIL` varchar(128) NOT NULL,  PRIMARY KEY  (`UID`),  UNIQUE KEY `NAME` (`NAME`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";   $m->DoQueryNoReturn($sql);
$sql="INSERT INTO `user` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '011', 'test@test.com');";   $m->DoQueryNoReturn($sql);
$sql="INSERT INTO `user` VALUES (2, 'test', '098f6bcd4621d373cade4e832627b4f6', '1122', 'test@test.com');";   $m->DoQueryNoReturn($sql);

?>